LastDateOfDayInQuarter

Syntax:

LastDateOfDayInQuarter(dateexpr, NumZ{day})

Description:
Returns the date of the last instance of the specified day in the quarter of the date specified. For example, this function could return the date of the last Monday of the next quarter.

Parameter Description

dateexpr A the date to be used when determining the last instance of the quarter.

NumZ{day} The day to check for.

ò vbSunday (1) - Sunday

ò vbMonday (2) - Monday

ò vbTuesday (3) - Tuesday

ò vbWednesday (4) - Wednesday

ò vbThursday (5) - Thursday

ò vbFriday (6) - Friday

ò vbSaturday (7) - Saturday

Example:

Sub Main
'return the date of the last Sunday of this quarter.
lastSundayofthisquarter= LastDateOfDayInQuarter(Now(),1)

'return the date of the last Friday of next quarter.
lastMondayofnextquarter = LastDateOfDayInQuarter(DateAdd(1,"q",Now()),6)

End Sub